SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND p.iPostType=4 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=1 AND MATCH (t.strSearch) AGAINST ('+things +that +sell +online' IN BOOLEAN MODE)) AND iCityID IN (9664,9652,9637,9644,9649,9749,9701,9638,9777,16667,9653,9670,9700,9789,9752,9764,9742,9632,9679,9788,9783,16172,9635,9695,9675,9680,9771,9751,9765,9643,9720,9773,9631,9657,9627,9744,9730,9708,16171,9634,9696,9778,9678,9674,9732,9756,9745,9793,9647,9633,9628,9727,9734,9655,9735,9717,9672,9666,9641,9724,9684,9677,9660,9659,9715,9669,9713,9711,9767,9625,9759,9726,9723,9797,9640,9794,9776,9639,9682,9772,9656,9688,9718,9629,9663,9707,9736,9645,9796,9737,9750,9729,9781,9702,9766,9661,9712,9770,6864,9698,9787,9630,9665,9699,9683,9671,9693,9775,9662,9785,9642,9686,9763,9753,8515,9728,9760,9738,9722,9754,9786,8599,9748,9706,9747,8402,9733,8465,9685,9703,9768,8217,8116,8600,8346,8164,8218,8124,8272,9741,8596,8607,8040,8343,8552,8591,9691,9755,9668,9689,9721,8371,8114,9761,9769,9758,8046,8185,8604,9650,9762,8513,9626,8152,6859,9705,9731,8512,9690,9784,8195,13019,8297,9673,6862,8548,9646,8236,9780,9667,8043,8094,9710,8568,9782,9779,8647,12585,8197,8045,8630,8379,8394,12511,8341,8436,9676,8646,8054,9790,8557,8137,12571,8633,12564,8313,8193,12581,16609,8519,8306,8076,12582,8577,8068,8292,9692,9719,13023,12532,9791,8514,9716) ORDER BY FIELD(iCityID, 9664,9652,9637,9644,9649,9749,9701,9638,9777,16667,9653,9670,9700,9789,9752,9764,9742,9632,9679,9788,9783,16172,9635,9695,9675,9680,9771,9751,9765,9643,9720,9773,9631,9657,9627,9744,9730,9708,16171,9634,9696,9778,9678,9674,9732,9756,9745,9793,9647,9633,9628,9727,9734,9655,9735,9717,9672,9666,9641,9724,9684,9677,9660,9659,9715,9669,9713,9711,9767,9625,9759,9726,9723,9797,9640,9794,9776,9639,9682,9772,9656,9688,9718,9629,9663,9707,9736,9645,9796,9737,9750,9729,9781,9702,9766,9661,9712,9770,6864,9698,9787,9630,9665,9699,9683,9671,9693,9775,9662,9785,9642,9686,9763,9753,8515,9728,9760,9738,9722,9754,9786,8599,9748,9706,9747,8402,9733,8465,9685,9703,9768,8217,8116,8600,8346,8164,8218,8124,8272,9741,8596,8607,8040,8343,8552,8591,9691,9755,9668,9689,9721,8371,8114,9761,9769,9758,8046,8185,8604,9650,9762,8513,9626,8152,6859,9705,9731,8512,9690,9784,8195,13019,8297,9673,6862,8548,9646,8236,9780,9667,8043,8094,9710,8568,9782,9779,8647,12585,8197,8045,8630,8379,8394,12511,8341,8436,9676,8646,8054,9790,8557,8137,12571,8633,12564,8313,8193,12581,16609,8519,8306,8076,12582,8577,8068,8292,9692,9719,13023,12532,9791,8514,9716) ASC, p.tmPosted DESC LIMIT 24 things that sell online, For Sale Classifieds, Buy Used, Electronics, Computers, Tablets, Mobiles in East Concord

Items for sale in East Concord - things that sell online

No results found!

Looking for something? Get notified when it's posted. Setup an Email Alert now!

East Concord

Items for Sale

Items for sale in East Concord - things that sell online

Similar searches: